Automated Monday morning reporting pipeline. Parses schedule data, generates analysis reports, archives history, and emails formatted huddle summaries to leadership each week.
Google Apps ScriptGoogle SheetsAuto-Emails
This is a Google Apps Script application. It runs inside Google Sheets and cannot be opened directly in a browser. Follow the setup steps below to deploy it to your Google account.
Features
Parses uploaded schedule files for weekly staffing data
Generates analysis reports with key metrics
Archives historical data for trend tracking
Automated email reports to configurable recipients
Monday sheet population with weekly summaries
Multiple report formats for different audiences
Setup Steps
Create a new Google Sheet for the Monday Huddle system.
Open Extensions → Apps Script and paste each .gs file.
Create an HTML file named Upload and paste Upload.html.
Run the initial setup function to create required sheet tabs.
Configure email recipients and report settings in the Config tab.
Set up a weekly time-driven trigger to run the Monday pipeline.